﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EasySiteTest" targetNamespace="http://tempuri.org/EasySiteTest.xsd" xmlns:mstns="http://tempuri.org/EasySiteTest.xsd" xmlns="http://tempuri.org/EasySiteTest.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="EasySiteConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="EasySiteConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.EasySite.Tests.Properties.Settings.GlobalReference.Default.EasySiteConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MenuItemTableAdapter" GeneratorDataComponentClassName="MenuItemTableAdapter" Name="MenuItem" UserDataComponentName="MenuItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.MenuItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MenuItem] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_ParentID = 1 AND [ParentID] IS NULL) OR ([ParentID] = @Original_ParentID)) AND ([DisplayText] = @Original_DisplayText) AND ((@IsNull_Controller = 1 AND [Controller] IS NULL) OR ([Controller] = @Original_Controller)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)) AND ((@IsNull_Href = 1 AND [Href] IS NULL) OR ([Href] = @Original_Href)) AND ((@IsNull_NeedAuthentication = 1 AND [NeedAuthentication] IS NULL) OR ([NeedAuthentication] = @Original_NeedAuthentication)) AND ([Sequence] = @Original_Sequence) AND ([Deleted] = @Original_Deleted) AND ((@IsNull_CreatedDate = 1 AND [CreatedDate] IS NULL) OR ([CreatedDate] = @Original_CreatedDate)) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Controller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Controller" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Href" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Href" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeedAuthentication" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MenuItem] ([Name], [ParentID], [DisplayText], [Controller], [Action], [Href], [NeedAuthentication], [Sequence], [Deleted], [CreatedDate], [UpdatedDate]) VALUES (@Name, @ParentID, @DisplayText, @Controller, @Action, @Href, @NeedAuthentication, @Sequence, @Deleted, @CreatedDate, @UpdatedDate);
SELECT ID, Name, ParentID, DisplayText, Controller, Action, Href, NeedAuthentication, Sequence, Deleted, CreatedDate, UpdatedDate FROM MenuItem WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Controller" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Href" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, ParentID, DisplayText, Controller, Action, Href, NeedAuthentication, Sequence, Deleted, CreatedDate, UpdatedDate FROM dbo.MenuItem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MenuItem] SET [Name] = @Name, [ParentID] = @ParentID, [DisplayText] = @DisplayText, [Controller] = @Controller, [Action] = @Action, [Href] = @Href, [NeedAuthentication] = @NeedAuthentication, [Sequence] = @Sequence, [Deleted] = @Deleted, [CreatedDate] = @CreatedDate, [UpdatedDate] = @UpdatedDate WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_ParentID = 1 AND [ParentID] IS NULL) OR ([ParentID] = @Original_ParentID)) AND ([DisplayText] = @Original_DisplayText) AND ((@IsNull_Controller = 1 AND [Controller] IS NULL) OR ([Controller] = @Original_Controller)) AND ((@IsNull_Action = 1 AND [Action] IS NULL) OR ([Action] = @Original_Action)) AND ((@IsNull_Href = 1 AND [Href] IS NULL) OR ([Href] = @Original_Href)) AND ((@IsNull_NeedAuthentication = 1 AND [NeedAuthentication] IS NULL) OR ([NeedAuthentication] = @Original_NeedAuthentication)) AND ([Sequence] = @Original_Sequence) AND ([Deleted] = @Original_Deleted) AND ((@IsNull_CreatedDate = 1 AND [CreatedDate] IS NULL) OR ([CreatedDate] = @Original_CreatedDate)) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)));
SELECT ID, Name, ParentID, DisplayText, Controller, Action, Href, NeedAuthentication, Sequence, Deleted, CreatedDate, UpdatedDate FROM MenuItem WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Controller" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Action" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Href" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Controller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Controller" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Controller" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Action" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Href" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Href" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Href" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeedAuthentication" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="DisplayText" DataSetColumn="DisplayText" />
              <Mapping SourceColumn="Controller" DataSetColumn="Controller" />
              <Mapping SourceColumn="Action" DataSetColumn="Action" />
              <Mapping SourceColumn="Href" DataSetColumn="Href" />
              <Mapping SourceColumn="NeedAuthentication" DataSetColumn="NeedAuthentication" />
              <Mapping SourceColumn="Sequence" DataSetColumn="Sequence" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserInRoleTableAdapter" GeneratorDataComponentClassName="UserInRoleTableAdapter" Name="UserInRole" UserDataComponentName="UserInRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.UserInRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UserInRole] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([RoleID] = @Original_RoleID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UserInRole] ([UserID], [RoleID]) VALUES (@UserID, @RoleID);
SELECT ID, UserID, RoleID FROM UserInRole WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, UserID, RoleID FROM dbo.UserInRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UserInRole] SET [UserID] = @UserID, [RoleID] = @RoleID WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([RoleID] = @Original_RoleID));
SELECT ID, UserID, RoleID FROM UserInRole WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MenuItemInRoleTableAdapter" GeneratorDataComponentClassName="MenuItemInRoleTableAdapter" Name="MenuItemInRole" UserDataComponentName="MenuItemInRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.MenuItemInRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MenuItemInRole] WHERE (([ID] = @Original_ID) AND ([MenuItemID] = @Original_MenuItemID) AND ([RoleID] = @Original_RoleID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MenuItemInRole] ([ID], [MenuItemID], [RoleID]) VALUES (@ID, @MenuItemID, @RoleID);
SELECT ID, MenuItemID, RoleID FROM MenuItemInRole WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, MenuItemID, RoleID FROM dbo.MenuItemInRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MenuItemInRole] SET [ID] = @ID, [MenuItemID] = @MenuItemID, [RoleID] = @RoleID WHERE (([ID] = @Original_ID) AND ([MenuItemID] = @Original_MenuItemID) AND ([RoleID] = @Original_RoleID));
SELECT ID, MenuItemID, RoleID FROM MenuItemInRole WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="MenuItemID" DataSetColumn="MenuItemID" />
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PageTableAdapter" GeneratorDataComponentClassName="PageTableAdapter" Name="Page" UserDataComponentName="PageTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.Page" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Page] WHERE (([ID] = @Original_ID) AND ((@IsNull_PageCategoryID = 1 AND [PageCategoryID] IS NULL) OR ([PageCategoryID] = @Original_PageCategoryID)) AND ([Url] = @Original_Url) AND ([LayoutSrc] = @Original_LayoutSrc) AND ([UseView] = @Original_UseView) AND ((@IsNull_ViewSrc = 1 AND [ViewSrc] IS NULL) OR ([ViewSrc] = @Original_ViewSrc)) AND ([Title] = @Original_Title) AND ((@IsNull_Keywords = 1 AND [Keywords] IS NULL) OR ([Keywords] = @Original_Keywords)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Deleted] = @Original_Deleted) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)) AND ([ReadsCount] = @Original_ReadsCount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Url" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LayoutSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LayoutSrc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UseView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UseView" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ViewSrc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ViewSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Keywords" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Keywords" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReadsCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReadsCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Page] ([PageCategoryID], [Url], [LayoutSrc], [UseView], [ViewSrc], [Content], [Title], [Keywords], [Description], [Deleted], [CreatedDate], [UpdatedDate], [ReadsCount]) VALUES (@PageCategoryID, @Url, @LayoutSrc, @UseView, @ViewSrc, @Content, @Title, @Keywords, @Description, @Deleted, @CreatedDate, @UpdatedDate, @ReadsCount);
SELECT ID, PageCategoryID, Url, LayoutSrc, UseView, ViewSrc, [Content], Title, Keywords, Description, Deleted, CreatedDate, UpdatedDate, ReadsCount FROM Page WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Url" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LayoutSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LayoutSrc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UseView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UseView" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ViewSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Keywords" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReadsCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReadsCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, PageCategoryID, Url, LayoutSrc, UseView, ViewSrc, Content, Title, Keywords, Description, Deleted, CreatedDate, UpdatedDate, ReadsCount FROM dbo.Page</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Page] SET [PageCategoryID] = @PageCategoryID, [Url] = @Url, [LayoutSrc] = @LayoutSrc, [UseView] = @UseView, [ViewSrc] = @ViewSrc, [Content] = @Content, [Title] = @Title, [Keywords] = @Keywords, [Description] = @Description, [Deleted] = @Deleted, [CreatedDate] = @CreatedDate, [UpdatedDate] = @UpdatedDate, [ReadsCount] = @ReadsCount WHERE (([ID] = @Original_ID) AND ((@IsNull_PageCategoryID = 1 AND [PageCategoryID] IS NULL) OR ([PageCategoryID] = @Original_PageCategoryID)) AND ([Url] = @Original_Url) AND ([LayoutSrc] = @Original_LayoutSrc) AND ([UseView] = @Original_UseView) AND ((@IsNull_ViewSrc = 1 AND [ViewSrc] IS NULL) OR ([ViewSrc] = @Original_ViewSrc)) AND ([Title] = @Original_Title) AND ((@IsNull_Keywords = 1 AND [Keywords] IS NULL) OR ([Keywords] = @Original_Keywords)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Deleted] = @Original_Deleted) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)) AND ([ReadsCount] = @Original_ReadsCount));
SELECT ID, PageCategoryID, Url, LayoutSrc, UseView, ViewSrc, [Content], Title, Keywords, Description, Deleted, CreatedDate, UpdatedDate, ReadsCount FROM Page WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Url" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LayoutSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LayoutSrc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@UseView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UseView" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ViewSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Keywords" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReadsCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReadsCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Url" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LayoutSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LayoutSrc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_UseView" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="UseView" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ViewSrc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ViewSrc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ViewSrc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Keywords" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Keywords" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Keywords" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReadsCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReadsCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="PageCategoryID" DataSetColumn="PageCategoryID" />
              <Mapping SourceColumn="Url" DataSetColumn="Url" />
              <Mapping SourceColumn="LayoutSrc" DataSetColumn="LayoutSrc" />
              <Mapping SourceColumn="UseView" DataSetColumn="UseView" />
              <Mapping SourceColumn="ViewSrc" DataSetColumn="ViewSrc" />
              <Mapping SourceColumn="Content" DataSetColumn="Content" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Keywords" DataSetColumn="Keywords" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
              <Mapping SourceColumn="ReadsCount" DataSetColumn="ReadsCount" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PageCategoryTableAdapter" GeneratorDataComponentClassName="PageCategoryTableAdapter" Name="PageCategory" UserDataComponentName="PageCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.PageCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PageCategory] WHERE (([ID] = @Original_ID) AND ((@IsNull_ParentID = 1 AND [ParentID] IS NULL) OR ([ParentID] = @Original_ParentID)) AND ([Name] = @Original_Name) AND ([DisplayText] = @Original_DisplayText) AND ([Sequence] = @Original_Sequence) AND ((@IsNull_NeedAuthentication = 1 AND [NeedAuthentication] IS NULL) OR ([NeedAuthentication] = @Original_NeedAuthentication)) AND ([Deleted] = @Original_Deleted) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeedAuthentication" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PageCategory] ([ParentID], [Name], [DisplayText], [Sequence], [NeedAuthentication], [Deleted], [CreatedDate], [UpdatedDate]) VALUES (@ParentID, @Name, @DisplayText, @Sequence, @NeedAuthentication, @Deleted, @CreatedDate, @UpdatedDate);
SELECT ID, ParentID, Name, DisplayText, Sequence, NeedAuthentication, Deleted, CreatedDate, UpdatedDate FROM PageCategory WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ParentID, Name, DisplayText, Sequence, NeedAuthentication, Deleted, CreatedDate, UpdatedDate FROM dbo.PageCategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PageCategory] SET [ParentID] = @ParentID, [Name] = @Name, [DisplayText] = @DisplayText, [Sequence] = @Sequence, [NeedAuthentication] = @NeedAuthentication, [Deleted] = @Deleted, [CreatedDate] = @CreatedDate, [UpdatedDate] = @UpdatedDate WHERE (([ID] = @Original_ID) AND ((@IsNull_ParentID = 1 AND [ParentID] IS NULL) OR ([ParentID] = @Original_ParentID)) AND ([Name] = @Original_Name) AND ([DisplayText] = @Original_DisplayText) AND ([Sequence] = @Original_Sequence) AND ((@IsNull_NeedAuthentication = 1 AND [NeedAuthentication] IS NULL) OR ([NeedAuthentication] = @Original_NeedAuthentication)) AND ([Deleted] = @Original_Deleted) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)));
SELECT ID, ParentID, Name, DisplayText, Sequence, NeedAuthentication, Deleted, CreatedDate, UpdatedDate FROM PageCategory WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sequence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sequence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeedAuthentication" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NeedAuthentication" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NeedAuthentication" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UpdatedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="DisplayText" DataSetColumn="DisplayText" />
              <Mapping SourceColumn="Sequence" DataSetColumn="Sequence" />
              <Mapping SourceColumn="NeedAuthentication" DataSetColumn="NeedAuthentication" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PageCategoryInRoleTableAdapter" GeneratorDataComponentClassName="PageCategoryInRoleTableAdapter" Name="PageCategoryInRole" UserDataComponentName="PageCategoryInRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.PageCategoryInRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PageCategoryInRole] WHERE (([ID] = @Original_ID) AND ([PageCategoryID] = @Original_PageCategoryID) AND ([RoleID] = @Original_RoleID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PageCategoryInRole] ([PageCategoryID], [RoleID]) VALUES (@PageCategoryID, @RoleID);
SELECT ID, PageCategoryID, RoleID FROM PageCategoryInRole WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, PageCategoryID, RoleID FROM dbo.PageCategoryInRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PageCategoryInRole] SET [PageCategoryID] = @PageCategoryID, [RoleID] = @RoleID WHERE (([ID] = @Original_ID) AND ([PageCategoryID] = @Original_PageCategoryID) AND ([RoleID] = @Original_RoleID));
SELECT ID, PageCategoryID, RoleID FROM PageCategoryInRole WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PageCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="PageCategoryID" DataSetColumn="PageCategoryID" />
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Role] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([DisplayText] = @Original_DisplayText) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Role] ([Name], [DisplayText], [Description]) VALUES (@Name, @DisplayText, @Description);
SELECT ID, Name, DisplayText, Description FROM Role WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, DisplayText, Description FROM dbo.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Role] SET [Name] = @Name, [DisplayText] = @DisplayText, [Description] = @Description WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([DisplayText] = @Original_DisplayText) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)));
SELECT ID, Name, DisplayText, Description FROM Role WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DisplayText" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DisplayText" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="DisplayText" DataSetColumn="DisplayText" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTableAdapter" GeneratorDataComponentClassName="UserTableAdapter" Name="User" UserDataComponentName="UserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EasySiteConnectionString (Settings)" DbObjectName="EasySiteTest.dbo.[User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[User] WHERE (([ID] = @Original_ID) AND ([Username] = @Original_Username) AND ([Password] = @Original_Password) AND ([Email] = @Original_Email) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_LastLogin = 1 AND [LastLogin] IS NULL) OR ([LastLogin] = @Original_LastLogin)) AND ((@IsNull_LastLoginIP = 1 AND [LastLoginIP] IS NULL) OR ([LastLoginIP] = @Original_LastLoginIP)) AND ([LoginCount] = @Original_LoginCount) AND ([Activated] = @Original_Activated) AND ([Deleted] = @Original_Deleted))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastLogin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastLoginIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastLoginIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoginCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoginCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Activated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[User] ([Username], [Password], [Email], [CreatedDate], [LastLogin], [LastLoginIP], [LoginCount], [Activated], [Deleted]) VALUES (@Username, @Password, @Email, @CreatedDate, @LastLogin, @LastLoginIP, @LoginCount, @Activated, @Deleted);
SELECT ID, Username, Password, Email, CreatedDate, LastLogin, LastLoginIP, LoginCount, Activated, Deleted FROM [User] WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastLoginIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoginCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoginCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Activated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Username, Password, Email, CreatedDate, LastLogin, LastLoginIP, LoginCount, Activated, Deleted FROM dbo.[User]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[User] SET [Username] = @Username, [Password] = @Password, [Email] = @Email, [CreatedDate] = @CreatedDate, [LastLogin] = @LastLogin, [LastLoginIP] = @LastLoginIP, [LoginCount] = @LoginCount, [Activated] = @Activated, [Deleted] = @Deleted WHERE (([ID] = @Original_ID) AND ([Username] = @Original_Username) AND ([Password] = @Original_Password) AND ([Email] = @Original_Email) AND ([CreatedDate] = @Original_CreatedDate) AND ((@IsNull_LastLogin = 1 AND [LastLogin] IS NULL) OR ([LastLogin] = @Original_LastLogin)) AND ((@IsNull_LastLoginIP = 1 AND [LastLoginIP] IS NULL) OR ([LastLoginIP] = @Original_LastLoginIP)) AND ([LoginCount] = @Original_LoginCount) AND ([Activated] = @Original_Activated) AND ([Deleted] = @Original_Deleted));
SELECT ID, Username, Password, Email, CreatedDate, LastLogin, LastLoginIP, LoginCount, Activated, Deleted FROM [User] WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastLoginIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoginCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoginCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Activated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastLogin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastLoginIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastLoginIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastLoginIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoginCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoginCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Activated" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="LastLogin" DataSetColumn="LastLogin" />
              <Mapping SourceColumn="LastLoginIP" DataSetColumn="LastLoginIP" />
              <Mapping SourceColumn="LoginCount" DataSetColumn="LoginCount" />
              <Mapping SourceColumn="Activated" DataSetColumn="Activated" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="EasySiteTest" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="EasySiteTest" msprop:Generator_UserDSName="EasySiteTest">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="MenuItem" msprop:Generator_TableClassName="MenuItemDataTable" msprop:Generator_TableVarName="tableMenuItem" msprop:Generator_TablePropName="MenuItem" msprop:Generator_RowDeletingName="MenuItemRowDeleting" msprop:Generator_UserTableName="MenuItem" msprop:Generator_RowChangingName="MenuItemRowChanging" msprop:Generator_RowEvHandlerName="MenuItemRowChangeEventHandler" msprop:Generator_RowDeletedName="MenuItemRowDeleted" msprop:Generator_RowEvArgName="MenuItemRowChangeEvent" msprop:Generator_RowChangedName="MenuItemRowChanged" msprop:Generator_RowClassName="MenuItemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:int" minOccurs="0" />
              <xs:element name="DisplayText" msprop:Generator_ColumnVarNameInTable="columnDisplayText" msprop:Generator_ColumnPropNameInRow="DisplayText" msprop:Generator_ColumnPropNameInTable="DisplayTextColumn" msprop:Generator_UserColumnName="DisplayText">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Controller" msprop:Generator_ColumnVarNameInTable="columnController" msprop:Generator_ColumnPropNameInRow="Controller" msprop:Generator_ColumnPropNameInTable="ControllerColumn" msprop:Generator_UserColumnName="Controller" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Action" msprop:Generator_ColumnVarNameInTable="columnAction" msprop:Generator_ColumnPropNameInRow="Action" msprop:Generator_ColumnPropNameInTable="ActionColumn" msprop:Generator_UserColumnName="Action" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Href" msprop:Generator_ColumnVarNameInTable="columnHref" msprop:Generator_ColumnPropNameInRow="Href" msprop:Generator_ColumnPropNameInTable="HrefColumn" msprop:Generator_UserColumnName="Href" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NeedAuthentication" msprop:Generator_ColumnVarNameInTable="columnNeedAuthentication" msprop:Generator_ColumnPropNameInRow="NeedAuthentication" msprop:Generator_ColumnPropNameInTable="NeedAuthenticationColumn" msprop:Generator_UserColumnName="NeedAuthentication" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sequence" msprop:Generator_ColumnVarNameInTable="columnSequence" msprop:Generator_ColumnPropNameInRow="Sequence" msprop:Generator_ColumnPropNameInTable="SequenceColumn" msprop:Generator_UserColumnName="Sequence" type="xs:int" />
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UpdatedDate" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserInRole" msprop:Generator_TableClassName="UserInRoleDataTable" msprop:Generator_TableVarName="tableUserInRole" msprop:Generator_TablePropName="UserInRole" msprop:Generator_RowDeletingName="UserInRoleRowDeleting" msprop:Generator_UserTableName="UserInRole" msprop:Generator_RowChangingName="UserInRoleRowChanging" msprop:Generator_RowEvHandlerName="UserInRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="UserInRoleRowDeleted" msprop:Generator_RowEvArgName="UserInRoleRowChangeEvent" msprop:Generator_RowChangedName="UserInRoleRowChanged" msprop:Generator_RowClassName="UserInRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
              <xs:element name="RoleID" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" msprop:Generator_UserColumnName="RoleID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MenuItemInRole" msprop:Generator_TableClassName="MenuItemInRoleDataTable" msprop:Generator_TableVarName="tableMenuItemInRole" msprop:Generator_TablePropName="MenuItemInRole" msprop:Generator_RowDeletingName="MenuItemInRoleRowDeleting" msprop:Generator_UserTableName="MenuItemInRole" msprop:Generator_RowChangingName="MenuItemInRoleRowChanging" msprop:Generator_RowEvHandlerName="MenuItemInRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="MenuItemInRoleRowDeleted" msprop:Generator_RowEvArgName="MenuItemInRoleRowChangeEvent" msprop:Generator_RowChangedName="MenuItemInRoleRowChanged" msprop:Generator_RowClassName="MenuItemInRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="MenuItemID" msprop:Generator_ColumnVarNameInTable="columnMenuItemID" msprop:Generator_ColumnPropNameInRow="MenuItemID" msprop:Generator_ColumnPropNameInTable="MenuItemIDColumn" msprop:Generator_UserColumnName="MenuItemID" type="xs:int" />
              <xs:element name="RoleID" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" msprop:Generator_UserColumnName="RoleID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Page" msprop:Generator_TableClassName="PageDataTable" msprop:Generator_TableVarName="tablePage" msprop:Generator_TablePropName="Page" msprop:Generator_RowDeletingName="PageRowDeleting" msprop:Generator_UserTableName="Page" msprop:Generator_RowChangingName="PageRowChanging" msprop:Generator_RowEvHandlerName="PageRowChangeEventHandler" msprop:Generator_RowDeletedName="PageRowDeleted" msprop:Generator_RowEvArgName="PageRowChangeEvent" msprop:Generator_RowChangedName="PageRowChanged" msprop:Generator_RowClassName="PageRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="PageCategoryID" msprop:Generator_ColumnVarNameInTable="columnPageCategoryID" msprop:Generator_ColumnPropNameInRow="PageCategoryID" msprop:Generator_ColumnPropNameInTable="PageCategoryIDColumn" msprop:Generator_UserColumnName="PageCategoryID" type="xs:int" minOccurs="0" />
              <xs:element name="Url" msprop:Generator_ColumnVarNameInTable="columnUrl" msprop:Generator_ColumnPropNameInRow="Url" msprop:Generator_ColumnPropNameInTable="UrlColumn" msprop:Generator_UserColumnName="Url">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LayoutSrc" msprop:Generator_ColumnVarNameInTable="columnLayoutSrc" msprop:Generator_ColumnPropNameInRow="LayoutSrc" msprop:Generator_ColumnPropNameInTable="LayoutSrcColumn" msprop:Generator_UserColumnName="LayoutSrc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UseView" msprop:Generator_ColumnVarNameInTable="columnUseView" msprop:Generator_ColumnPropNameInRow="UseView" msprop:Generator_ColumnPropNameInTable="UseViewColumn" msprop:Generator_UserColumnName="UseView" type="xs:boolean" />
              <xs:element name="ViewSrc" msprop:Generator_ColumnVarNameInTable="columnViewSrc" msprop:Generator_ColumnPropNameInRow="ViewSrc" msprop:Generator_ColumnPropNameInTable="ViewSrcColumn" msprop:Generator_UserColumnName="ViewSrc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content" msprop:Generator_ColumnVarNameInTable="columnContent" msprop:Generator_ColumnPropNameInRow="Content" msprop:Generator_ColumnPropNameInTable="ContentColumn" msprop:Generator_UserColumnName="Content" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Keywords" msprop:Generator_ColumnVarNameInTable="columnKeywords" msprop:Generator_ColumnPropNameInRow="Keywords" msprop:Generator_ColumnPropNameInTable="KeywordsColumn" msprop:Generator_UserColumnName="Keywords" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" />
              <xs:element name="UpdatedDate" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ReadsCount" msprop:Generator_ColumnVarNameInTable="columnReadsCount" msprop:Generator_ColumnPropNameInRow="ReadsCount" msprop:Generator_ColumnPropNameInTable="ReadsCountColumn" msprop:Generator_UserColumnName="ReadsCount" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PageCategory" msprop:Generator_TableClassName="PageCategoryDataTable" msprop:Generator_TableVarName="tablePageCategory" msprop:Generator_TablePropName="PageCategory" msprop:Generator_RowDeletingName="PageCategoryRowDeleting" msprop:Generator_UserTableName="PageCategory" msprop:Generator_RowChangingName="PageCategoryRowChanging" msprop:Generator_RowEvHandlerName="PageCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="PageCategoryRowDeleted" msprop:Generator_RowEvArgName="PageCategoryRowChangeEvent" msprop:Generator_RowChangedName="PageCategoryRowChanged" msprop:Generator_RowClassName="PageCategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayText" msprop:Generator_ColumnVarNameInTable="columnDisplayText" msprop:Generator_ColumnPropNameInRow="DisplayText" msprop:Generator_ColumnPropNameInTable="DisplayTextColumn" msprop:Generator_UserColumnName="DisplayText">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sequence" msprop:Generator_ColumnVarNameInTable="columnSequence" msprop:Generator_ColumnPropNameInRow="Sequence" msprop:Generator_ColumnPropNameInTable="SequenceColumn" msprop:Generator_UserColumnName="Sequence" type="xs:int" />
              <xs:element name="NeedAuthentication" msprop:Generator_ColumnVarNameInTable="columnNeedAuthentication" msprop:Generator_ColumnPropNameInRow="NeedAuthentication" msprop:Generator_ColumnPropNameInTable="NeedAuthenticationColumn" msprop:Generator_UserColumnName="NeedAuthentication" type="xs:boolean" minOccurs="0" />
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" />
              <xs:element name="UpdatedDate" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PageCategoryInRole" msprop:Generator_TableClassName="PageCategoryInRoleDataTable" msprop:Generator_TableVarName="tablePageCategoryInRole" msprop:Generator_TablePropName="PageCategoryInRole" msprop:Generator_RowDeletingName="PageCategoryInRoleRowDeleting" msprop:Generator_UserTableName="PageCategoryInRole" msprop:Generator_RowChangingName="PageCategoryInRoleRowChanging" msprop:Generator_RowEvHandlerName="PageCategoryInRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="PageCategoryInRoleRowDeleted" msprop:Generator_RowEvArgName="PageCategoryInRoleRowChangeEvent" msprop:Generator_RowChangedName="PageCategoryInRoleRowChanged" msprop:Generator_RowClassName="PageCategoryInRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="PageCategoryID" msprop:Generator_ColumnVarNameInTable="columnPageCategoryID" msprop:Generator_ColumnPropNameInRow="PageCategoryID" msprop:Generator_ColumnPropNameInTable="PageCategoryIDColumn" msprop:Generator_UserColumnName="PageCategoryID" type="xs:int" />
              <xs:element name="RoleID" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" msprop:Generator_UserColumnName="RoleID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_TablePropName="Role" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_UserTableName="Role" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowClassName="RoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayText" msprop:Generator_ColumnVarNameInTable="columnDisplayText" msprop:Generator_ColumnPropNameInRow="DisplayText" msprop:Generator_ColumnPropNameInTable="DisplayTextColumn" msprop:Generator_UserColumnName="DisplayText">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="User" msprop:Generator_TableClassName="UserDataTable" msprop:Generator_TableVarName="tableUser" msprop:Generator_TablePropName="User" msprop:Generator_RowDeletingName="UserRowDeleting" msprop:Generator_UserTableName="User" msprop:Generator_RowChangingName="UserRowChanging" msprop:Generator_RowEvHandlerName="UserRowChangeEventHandler" msprop:Generator_RowDeletedName="UserRowDeleted" msprop:Generator_RowEvArgName="UserRowChangeEvent" msprop:Generator_RowChangedName="UserRowChanged" msprop:Generator_RowClassName="UserRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" />
              <xs:element name="LastLogin" msprop:Generator_ColumnVarNameInTable="columnLastLogin" msprop:Generator_ColumnPropNameInRow="LastLogin" msprop:Generator_ColumnPropNameInTable="LastLoginColumn" msprop:Generator_UserColumnName="LastLogin" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastLoginIP" msprop:Generator_ColumnVarNameInTable="columnLastLoginIP" msprop:Generator_ColumnPropNameInRow="LastLoginIP" msprop:Generator_ColumnPropNameInTable="LastLoginIPColumn" msprop:Generator_UserColumnName="LastLoginIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LoginCount" msprop:Generator_ColumnVarNameInTable="columnLoginCount" msprop:Generator_ColumnPropNameInRow="LoginCount" msprop:Generator_ColumnPropNameInTable="LoginCountColumn" msprop:Generator_UserColumnName="LoginCount" type="xs:int" />
              <xs:element name="Activated" msprop:Generator_ColumnVarNameInTable="columnActivated" msprop:Generator_ColumnPropNameInRow="Activated" msprop:Generator_ColumnPropNameInTable="ActivatedColumn" msprop:Generator_UserColumnName="Activated" type="xs:boolean" />
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MenuItem" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="UserInRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserInRole" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="MenuItemInRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MenuItemInRole" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Page_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Page" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PageCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PageCategory" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PageCategoryInRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PageCategoryInRole" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:User" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_MenuItem_MenuItemParent" msdata:parent="MenuItem" msdata:child="MenuItem" msdata:parentkey="ID" msdata:childkey="ParentID" msprop:Generator_UserChildTable="MenuItem" msprop:Generator_ChildPropName="GetMenuItemRows" msprop:Generator_UserParentTable="MenuItem" msprop:Generator_UserRelationName="FK_MenuItem_MenuItemParent" msprop:Generator_RelationVarName="relationFK_MenuItem_MenuItemParent" msprop:Generator_ParentPropName="MenuItemRowParent" />
      <msdata:Relationship name="FK_UserInRole_Role" msdata:parent="Role" msdata:child="UserInRole" msdata:parentkey="ID" msdata:childkey="RoleID" msprop:Generator_UserChildTable="UserInRole" msprop:Generator_ChildPropName="GetUserInRoleRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_UserInRole_Role" msprop:Generator_RelationVarName="relationFK_UserInRole_Role" msprop:Generator_UserParentTable="Role" />
      <msdata:Relationship name="FK_UserInRole_User" msdata:parent="User" msdata:child="UserInRole" msdata:parentkey="ID" msdata:childkey="UserID" msprop:Generator_UserChildTable="UserInRole" msprop:Generator_ChildPropName="GetUserInRoleRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_UserInRole_User" msprop:Generator_RelationVarName="relationFK_UserInRole_User" msprop:Generator_UserParentTable="User" />
      <msdata:Relationship name="FK_MenuItemInRole_MenuItem" msdata:parent="MenuItem" msdata:child="MenuItemInRole" msdata:parentkey="ID" msdata:childkey="MenuItemID" msprop:Generator_UserChildTable="MenuItemInRole" msprop:Generator_ChildPropName="GetMenuItemInRoleRows" msprop:Generator_ParentPropName="MenuItemRow" msprop:Generator_UserRelationName="FK_MenuItemInRole_MenuItem" msprop:Generator_RelationVarName="relationFK_MenuItemInRole_MenuItem" msprop:Generator_UserParentTable="MenuItem" />
      <msdata:Relationship name="FK_MenuItemInRole_Role" msdata:parent="Role" msdata:child="MenuItemInRole" msdata:parentkey="ID" msdata:childkey="RoleID" msprop:Generator_UserChildTable="MenuItemInRole" msprop:Generator_ChildPropName="GetMenuItemInRoleRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_MenuItemInRole_Role" msprop:Generator_RelationVarName="relationFK_MenuItemInRole_Role" msprop:Generator_UserParentTable="Role" />
      <msdata:Relationship name="FK_Page_PageCategory" msdata:parent="PageCategory" msdata:child="Page" msdata:parentkey="ID" msdata:childkey="PageCategoryID" msprop:Generator_UserChildTable="Page" msprop:Generator_ChildPropName="GetPageRows" msprop:Generator_ParentPropName="PageCategoryRow" msprop:Generator_UserRelationName="FK_Page_PageCategory" msprop:Generator_RelationVarName="relationFK_Page_PageCategory" msprop:Generator_UserParentTable="PageCategory" />
      <msdata:Relationship name="FK_PageCategory_PageCategoryParent" msdata:parent="PageCategory" msdata:child="PageCategory" msdata:parentkey="ID" msdata:childkey="ParentID" msprop:Generator_UserChildTable="PageCategory" msprop:Generator_ChildPropName="GetPageCategoryRows" msprop:Generator_UserParentTable="PageCategory" msprop:Generator_UserRelationName="FK_PageCategory_PageCategoryParent" msprop:Generator_RelationVarName="relationFK_PageCategory_PageCategoryParent" msprop:Generator_ParentPropName="PageCategoryRowParent" />
      <msdata:Relationship name="FK_PageCategoryInRole_PageCategory" msdata:parent="PageCategory" msdata:child="PageCategoryInRole" msdata:parentkey="ID" msdata:childkey="PageCategoryID" msprop:Generator_UserChildTable="PageCategoryInRole" msprop:Generator_ChildPropName="GetPageCategoryInRoleRows" msprop:Generator_ParentPropName="PageCategoryRow" msprop:Generator_UserRelationName="FK_PageCategoryInRole_PageCategory" msprop:Generator_RelationVarName="relationFK_PageCategoryInRole_PageCategory" msprop:Generator_UserParentTable="PageCategory" />
      <msdata:Relationship name="FK_PageCategoryInRole_Role" msdata:parent="Role" msdata:child="PageCategoryInRole" msdata:parentkey="ID" msdata:childkey="RoleID" msprop:Generator_UserChildTable="PageCategoryInRole" msprop:Generator_ChildPropName="GetPageCategoryInRoleRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_PageCategoryInRole_Role" msprop:Generator_RelationVarName="relationFK_PageCategoryInRole_Role" msprop:Generator_UserParentTable="Role" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>